package com.gxan.service;

import com.gxan.common.LayuiRepResult;
import com.gxan.pojo.SalStandard;

import java.sql.SQLException;
import java.util.List;

public interface StandardService {
    /**
     * 查询所有小区数据-分页
     *
     * @param page  当前页码数
     * @param limit 每页显示的条数
     * @return
     */
    LayuiRepResult salFindAll(Integer page, Integer limit);

    /**
     * 添加薪酬标准
     * @param salStandard
     * @return
     * @throws SQLException
     */
    int addStandard(SalStandard salStandard) throws SQLException;

    /**
     * 修改
     * @param salStandard
     * @return
     * @throws SQLException
     */
    int updateStandard(SalStandard salStandard) throws SQLException;
    /**
     * 复核
     * @param salStandard
     * @return
     * @throws SQLException
     */
    int reviewStandard(SalStandard salStandard) throws SQLException;
    /**
     * 变更
     * @param salStandard
     * @return
     * @throws SQLException
     */
    int changeStandard(SalStandard salStandard) throws SQLException;
    /**
     * 明细
     * @param salStandard
     * @return
     * @throws SQLException
     */
    int detailsStandard(SalStandard salStandard) throws SQLException;

    /**
     * 删除
     * @param sal_standard_code 标准编号
     * @return
     * @throws SQLException
     */
    int deleteStandard(String sal_standard_code) throws  SQLException;

    /**
     * 搜索
     * @param page
     * @param limit
     * @return
     */
    List<SalStandard> searchStandard(Integer page,Integer limit,String sal_standard_name,Integer review_status) throws SQLException;

    int countSearchStandard(String sal_standard_name,Integer review_status) throws SQLException;
}
